Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
LicensePlateIssuerCode (FK) | A unique system generated identifier for the external agency that provides Party Identification codes for People and Organizations. Eg: Dun & Bradstreet, Standard & Poors, NYSC, NASDAQ, UCC for Organizations. Various government agencies for People, eg: SocialSecurity, Health Administration, Drivers Licensing, etc. | ID_PA_PVR_EXTRN | Identity | integer | ExternalPartyIdentificationProvider(PA_PVR_EXTRN_IDTN) |
LicensePlateNumber | The license plate number for the vehicle being fueled. | ED_LSC_PLT | IdentityAlphaNumeric | varchar(20) | |
VehicleID | A unique customer assigned identifier for the vehicle being fueled. Usually this will be the vehicle's license plate number, but not always. | ID_VH | IdentityAlphaNumeric | varchar(20) | |
DriverID | A unique customer assigned identifier for the driver making the purchase. | ID_DRV | IdentityAlphaNumeric | varchar(20) | |
WorkOrderID | A unique customer assigned identifier for the job or work-order that the purchase will be attributed to by the customer. | ID_WRK_ORD | IdentityAlphaNumeric | varchar(20) | |
TemporaryVehicleFlag | A flag denoting that this fleet information refers to a temporary vehicle, which means there is no valid VehicleID present. | FL_VH_TMP | Flag | integer | |
OdometerReading | The OdometerReading for the vehicle being fueled. | QU_RDG_ODO | Quantity | DECIMAL(9,3) | |